      ╒═══════════════════════════════════════════════════════════════════╕
      │                     Miscellaneous Utilities                       │
      ╘═══════════════════════════════════════════════════════════════════╛

      There are currently four utilities available under "Miscellaneous
      Utilities" in the main menu. More will be added as needed. They will
      allow you to: a) search and replace data in your fields, b) convert
      data in fields to all upper or upper/lower case, c) modify the field
      order of a database, and d) query the zippy database which requires
      the optional Zippy database.
      
                          A) Search and Replace
                          B) Convert UPPER/lower Case
                          C) Modify Field Order
                          D) Search Zippy Database


      A) Search and Replace
      ─────────────────────────────────────────────────────────────────────
      This selection will search for specific data in a field and then
      replace it with the new data that you specify.

      This will work on all the records in the database file. Simply select
      the field you want to search for data in. Then, enter the field
      content you want DDFile to look for and replace. Then, enter the new
      data to replace the old.

      If a character or memo field is selected and old data is specified,
      you will be asked if you want to search within the field and replace
      only the data specified.

      When finished, the total number of records with the new field content
      is displayed.


      B) Convert UPPER/lower Case
      ─────────────────────────────────────────────────────────────────────
      This selection will convert data in a field to all upper case or
      upper/lower (upper case first character of each word and lower case
      the rest). This will work on all the records in the database file.
      Select the field you want to convert data in and select either
      "UPPER/lower" or "All UPPER" from the sub-menu.


      C) Modify Field Order
      ─────────────────────────────────────────────────────────────────────
      This selection will allow you modify the field arrangement of the
      currently selected database. The changes will not take place in the
      current file.  It is only used as a model to create a new file with
      the new field order.

      The records in the currently selected database can be put into the
      new database field order using the following 2-step process:

          1) When finished with this procedure, select the newly created
             database with the new field order.

          2) Import the records from the prior database into the new
             database using "Import/Export dB3/ASCII Files" in the main
             menu. Import in dBASE III format. See "Importing & Exporting"
             in the on-line documentation.

      This will also create a database definition file for the new field
      order, eliminating the need to place the fields on the screen after
      modifying the field order.

      All fields must be selected. After a field is selected, the order
      number of that field is placed to the right of it. The fields may be
      selected in any order you wish. When all fields have been selected, a
      new empty database will be created with the new order.

      If you do not want to include some of the fields in the new database,
      select them for now but before importing the old records into it,
      modify it with "Modify an Existing Database" and delete the unwanted
      fields. See "Creating/Modifying a Database" in the on-line
      documentation.


      D) Search Zippy Database
      ─────────────────────────────────────────────────────────────────────
      Zippy is an optional database of all the cities, states, area codes
      and zip codes in the United States. Zippy is available for an
      additional cost. You will need a hard drive with at least 2.5 MB of
      free disk space.

      Once you have zippy installed you will be able to make this
      selection. A sub-menu will open allowing you to search for a City,
      State, Zip Code, or Area Code. To look up a zip code for a particular
      city, for example, select City and then enter the city name. Next,
      all the cities in the United States by that name will appear in a
      scrollable window with their corresponding state, area code, and zip
      code. This database can be cross-referenced to look up any data on
      any of the four selections.

